Open topic with navigation

Work Item Snapshot Weekly

Work Item Snapshot Weekly iCube enables you to create ad hoc reports to analyze the flow of work items as it progresses through various status categories. Using this iCube, you can chart a weekly average age report. You can view a snapshot of historical data from the past six months.

Attributes

Expand this link to view the list of attributes available as part of the Work Item Snapshot Weekly iCube.

Attributes	Description
Assigned To	User responsible for working on the Work Item
Calendar Month	Gregorian calendar month displayed in the format 'Mon YYYY'
Calendar Week	Gregorian calendar week displaying the week number. For example, W21, W22
Cancelled DateTime	Date and time when the work item was cancelled
Completed DateTime	Date and time when the work item was completed
Created DateTime	Date and time at which the Work Item was created
Date	Date on which the status of the Work Item moved to 'Created', 'In Progress', 'Resolved', or 'Completed'
Due Date	Date by when the Work Item is scheduled for completion
Earliest Fix Version	Version to which the selected work item is associated as 'Fix Version'
In Progress DateTime	Date and time at which the Work Item first moved to the 'In Progress' status category
In Progress Flag	Indicates whether the Work Item is currently in the 'In Progress' status category
Last Iteration	The last sprint (iteration) to which the work item is associated with
Last Updated DateTime	Date and time at which the work item was last updated
Overdue Flag	Indicates whether the Work Item is overdue (Current date is past the due date and the status category is less than 'Resolved')
Priority	Priority of the Work Item
Project	Project to which the Work Item is associated
Proposed Flag	Indicates whether the Work Item is currently in the 'Proposed' status category
Reassignment Count	Count of the number of times a work item was reassigned
Reopen Count	Count of the number of times a work item was reopened
Reopened Flag	Indicates whether the Work Item has ever been reopened
Resolved DateTime	Date and time at which the Work Item was last Resolved
Status (Source)	Status of the work item as mentioned in the source
Summary	Title or brief summary about the Work Item
Work Item	Work Item refers to an issue that represents work to be completed. Work items can be of various types, such as task, enhancement, bug, epic, and so on
Work Item Number	Unique identifier for the Work Item

Metrics

Expand this link to view the list of metrics available as part of the Work Item Snapshot Weekly iCube.

Metric Name	Description	Formula	Expected Value
Avg of Age Since Creation (Days)	Average age of the work item in days	[Age Since Creation Monthly] / ([Created Work Items - Monthly] * 86400.0)	>0
Created Work Items	Count of all work items that are created	Count [Work Items Created]	>=0
In Progress Work Items	Count of all work items whose current status category is "In Progress"	Count [Work Items In Progress]	>=0
Max of Age Since Creation (Days)	Maximum time for which the Work Item was Created	Max(([Age Since Creation Monthly] / 86400.0))	>0
Min of Age Since Creation (Days)	Minimum time for which the Work Item was Created	Min(([Age Since Creation Monthly] / 86400.0))	>0
Proposed Work Items	Count of all work items whose current status category is "Proposed"	Count (Created Work Items) WHERE Work Item Proposed Flag (ID) = 'Y'	0 or >0
Reopened Work Items Backlog	Total number of work items that have been reopened (Status category changes from "Resolved" or "Closed" to an earlier status)	Sum [Reopened Count] Where Reopened Flag (ID) = Y	Closer to 0 is ideal
Story Points	Story points assigned to the work item.	Sum (Story Points)	>0